package cn.itcast.bos.dao.base;



import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;

import cn.itcast.bos.domain.base.Standard;

public interface StandardRepository extends JpaRepository<Standard, Integer>{
	
	//基于一列查询，等值查询
	public List<Standard> findByName(String name);
	
	//模糊查询
	public List<Standard> findByNameLike(String name);
	
	//不按命名规则写的查询方法在Query中配置JPQA
	@Query(value="from Standard where name=?", nativeQuery=false)
	public List<Standard> queryName(String name);
	
	
	//不按命名规则写的查询方法
	@Query
	public List<Standard> queryName2(String name);
	
	
	//修改操作
	@Query(value="update Standard set minLength=?2 where id=?1",nativeQuery=false)
	@Modifying
	public void update(Integer id, Integer minLength);
		
}
